package com.gesee.zyspps.activity;

import com.gesee.zyspps.ZSApplication;
import com.gesee.zyspps.db.CmsPipelineField;

/**
 * 
* @ClassName: DataInitFiled
* @Description: TODO(初始化字段表)
* @author fujianxiong
* @date 2015-9-1 下午9:23:35
*
 */
public class DataInitFiled
{
    public static void initFiled(){
        //点
        CmsPipelineField ExpNo = new CmsPipelineField("物探点号","ALL","文本","50","点库","","管线小类代码+2位管理区域代码+6位自然顺序号，应保证编码工程内唯一",1);
        CmsPipelineField MapNo = new CmsPipelineField("图上点号","ALL","文本","50","点库","","管线小类代码+自然顺序号，应保证编号图幅内唯一",2);
        CmsPipelineField WDeep = new CmsPipelineField("井底深","ALL","数值","4,2","点库","","单位：米",3);
        CmsPipelineField PCode = new CmsPipelineField("管线类型","ALL","文本","50","点库","","管线小类代码",4);
        CmsPipelineField Subsid = new CmsPipelineField("附属物","ALL","文本","255","点库","","",5);
        CmsPipelineField Feature = new CmsPipelineField("特征","ALL","文本","255","点库","","",6);
        CmsPipelineField Visibility = new CmsPipelineField("可见性","ALL","布尔","1","点库","","",7);
        CmsPipelineField Mtype = new CmsPipelineField("井盖规格","ALL","文本","50","点库","","",8);
        CmsPipelineField Wcover = new CmsPipelineField("井盖材质","ALL","文本","50","点库","","",9);
        CmsPipelineField Msize = new CmsPipelineField("井盖尺寸","ALL","文本","50","点库","","",10);
        CmsPipelineField Wdepth = new CmsPipelineField("井筒深度","ALL","数值","12,3","点库","","",11);
        CmsPipelineField Hsize = new CmsPipelineField("井室尺寸","ALL","文本","50","点库","","",12);
        CmsPipelineField Sblock = new CmsPipelineField("淤堵情况","ALL","文本","50","点库","","",13);
        
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(ExpNo);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(MapNo);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(WDeep);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(PCode);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Subsid);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Feature);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Visibility);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Mtype);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Wcover);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Msize);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Wdepth);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Hsize);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Sblock);
        
        //线
        CmsPipelineField PipeLength = new CmsPipelineField("管线长度","ALL","数值","12,3","线库","","单位：米 ",14);
        CmsPipelineField S_Point = new CmsPipelineField("起始物探点号","ALL","文本","50","线库","","",15);
        CmsPipelineField E_Point = new CmsPipelineField("终止物探点号","ALL","文本","50","线库","","",16);
        CmsPipelineField S_Deep = new CmsPipelineField("起始埋深","ALL","数值","4,2","线库","","单位：米 ",17);
        CmsPipelineField E_Deep = new CmsPipelineField("终止埋深","ALL","数值","4,2","线库","","单位：米 ",18);
        CmsPipelineField PCodeXian = new CmsPipelineField("管线类型","ALL","文本","50","线库","","",19);
        CmsPipelineField DType = new CmsPipelineField("埋设方式","ALL","文本","50","线库","","直埋；套管；管块；小管沟；矩形管沟；拱形管沟；架空",20);
        CmsPipelineField Material = new CmsPipelineField("材质","ALL","文本","50","线库","","管道或线缆材质",21);
        CmsPipelineField DSize = new CmsPipelineField("管径或断面尺寸","ALL","文本","50","线库","","直径或宽X高或内径+外径（热力）单位：毫米",22);
        CmsPipelineField PD_S = new CmsPipelineField("套管或管沟尺寸","ALL","文本","50","线库","","格式：尺寸/材质",23);
        CmsPipelineField Pressure = new CmsPipelineField("压力","ALL","文本","50","线库","","燃气、工业管线压力，排水是否有压",24);
        CmsPipelineField Voltage = new CmsPipelineField("电压","ALL","文本","50","线库","","单位：千伏“kV”",25);
        CmsPipelineField Direction = new CmsPipelineField("流向","ALL","布尔","1","线库","","0—起点到终点；1—终点到起点",26);
        CmsPipelineField Cable = new CmsPipelineField("电缆条数","ALL","整形","","线库","","",27);
        CmsPipelineField Hole = new CmsPipelineField("总孔数","ALL","整形","","线库","","",28);
        CmsPipelineField Uhole = new CmsPipelineField("已用孔数","ALL","整形","","线库","","",29);
        
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(PipeLength);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(S_Point);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(E_Point);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(S_Deep);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(E_Deep);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(PCodeXian);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(DType);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Material);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(DSize);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(PD_S);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Pressure);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Voltage);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Direction);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Cable);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Hole);
        ZSApplication.getDaoSession("zyspps-db").getCmsPipelineFieldDao().insert(Uhole);
        
    }
}
